package guoanmaker.operator.business.repository;

import java.util.List;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.operator.business.model.OperatorCommonServiceDownNew;

public interface OperatorCommonServiceDownNewRepository extends JpaRepository<OperatorCommonServiceDownNew, String>, JpaSpecificationExecutor<OperatorCommonServiceDownNew> {
	@Modifying
	@Transactional
	@Query("delete from OperatorCommonServiceDownNew  where commonServiceNewId=:id")
	public void deleteAllCommonServiceDownByCommonServiceNewId(@Param("id") String id);
	@Query("select c from OperatorCommonServiceDownNew c where c.commonServiceNewId=:id")
	public List<OperatorCommonServiceDownNew> findCommonServiceDownByCommonServiceNewId(@Param("id") String id);

}
